<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Step 3: Registering the SQL Server Database">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="en-us_topic_0000001839245581.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
<meta name="DC.Publisher" content="20240608">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="EN-US_TOPIC_0000001792526314">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Step 3: Registering the SQL Server Database</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="EN-US_TOPIC_0000001792526314"></a><a name="EN-US_TOPIC_0000001792526314"></a>

<h1 class="topictitle1">Step 3: Registering the SQL Server Database</h1>
<div><p>After ProtectAgent is installed on the host where the SQL Server database resides, the <span>OceanProtect</span> automatically discovers the SQL Server database host. You need to register the database on the management page to protect it.</p>
<div class="section"><h4 class="sectiontitle">Prerequisites</h4><p>Before backing up or restoring a database, you need to add the login credential of the database to the <span>OceanProtect</span>. <span><strong>Windows Authentication</strong></span> and <span><strong>SQL Server Authentication</strong></span> modes are supported.</p>
<ul><li>When <span><strong>Windows Authentication</strong></span> is enabled on the database, the SQL Server database is automatically registered with the <span>OceanProtect</span>, and the authentication status of the database is automatically displayed as <strong>Authenticated</strong> on the management page.</li><li>If <span class="uicontrol"><b><span><strong>Unauthenticated</strong></span></b></span> is displayed on the management portal, the authentication mode of the newly registered database is <span class="uicontrol"><b><span><strong>Database authentication</strong></span></b></span>. In this case, you need to enter the authentication information.</li></ul>
</div>
<div class="section"><h4 class="sectiontitle">Registering a Single SQL Server Database Instance</h4><ol><li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000001792526314__en-us_topic_0000001839142377_uicontrol114088356363"><b><span id="EN-US_TOPIC_0000001792526314__en-us_topic_0000001839142377_text1840913533616"><strong>Protection</strong></span> &gt; Databases &gt; SQL Server</b></span>.</span></li><li><span>Click the <span class="uicontrol"><b><span><strong>Instance</strong></span></b></span> tab.</span></li><li><span>Click <span class="uicontrol"><b><span><strong>Register</strong></span></b></span> to register the SQL Server database.</span></li><li><span>Set <span class="uicontrol"><b><span><strong>Type</strong></span></b></span> to <span class="uicontrol"><b><span><strong>Single instance</strong></span></b></span>.</span></li><li><span>Configure the database instance and its authentication information.</span><p><p><a href="#EN-US_TOPIC_0000001792526314__en-us_topic_0000001311214069_table241515964115">Table 1</a> describes the related parameters.</p>

<div class="tablenoborder"><a name="EN-US_TOPIC_0000001792526314__en-us_topic_0000001311214069_table241515964115"></a><a name="en-us_topic_0000001311214069_table241515964115"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001792526314__en-us_topic_0000001311214069_table241515964115" frame="border" border="1" rules="all"><caption><b>Table 1 </b>SQL Server single-instance registration information</caption><colgroup><col style="width:25.629999999999995%"><col style="width:74.37%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="25.629999999999995%" id="mcps1.3.3.2.5.2.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="74.37%" id="mcps1.3.3.2.5.2.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p id="EN-US_TOPIC_0000001792526314__p157991143121110"><strong id="EN-US_TOPIC_0000001792526314__b17667192119556">SQL Server Network Name</strong></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p id="EN-US_TOPIC_0000001792526314__p1579919436116">Network name of the SQL Server. The default value is the host name.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p id="EN-US_TOPIC_0000001792526314__en-us_topic_0000001311214069_p0414115904113"><strong id="EN-US_TOPIC_0000001792526314__b43796208556">Named Instance</strong></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>Instance name.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p><span><strong>Hosts</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>Database host to be registered.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p><span><strong>Authentication Method</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>The instance authentication mode can be OS authentication or database authentication.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p><span><strong>Database Username</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>Name of the database administrator.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.3.2.5.2.2.2.3.1.1 "><p><span><strong>Database Password</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.3.2.5.2.2.2.3.1.2 "><p>Password of the database administrator.</p>
</td>
</tr>
</tbody>
</table>
</div>
</p></li><li><span>Click <span class="uicontrol"><b>OK</b></span>.</span></li></ol>
</div>
<div class="section"><h4 class="sectiontitle">Registering a SQL Server Cluster Instance</h4><p><strong>Prerequisites</strong></p>
<div class="p">Before registering a SQL Server cluster instance, ensure that each database host in the cluster has been registered.<div class="note"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p>The names of databases with which all hosts in the cluster are registered must be the same.</p>
</div></div>
</div>
<p><strong>Procedure</strong></p>
<ol><li><span>Create a cluster.</span><p><ol type="a"><li>On the SQL Server page, click the <span class="uicontrol"><b><span><strong>Cluster</strong></span></b></span> tab.</li><li>Click <span class="uicontrol"><b><span><strong>Register</strong></span></b></span>.</li><li>On the <span class="uicontrol"><b><span><strong>Register</strong></span></b></span> page, customize the cluster name and select the cluster node.</li><li>Click <span class="uicontrol"><b>OK</b></span>.</li></ol>
</p></li><li><span>Register a cluster instance.</span><p><ol type="a"><li>On the SQL Server page, click the <span class="uicontrol"><b><span><strong>Instance</strong></span></b></span> tab.</li><li>Click <span class="uicontrol"><b><span><strong>Register</strong></span></b></span>.</li><li>Set <span class="uicontrol"><b><span><strong>Type</strong></span></b></span> to <span class="uicontrol"><b><span><strong>Cluster instance</strong></span></b></span>.</li><li>Configure the database instance and its authentication information.<p><a href="#EN-US_TOPIC_0000001792526314__table163871610417">Table 2</a> describes the related parameters.</p>

<div class="tablenoborder"><a name="EN-US_TOPIC_0000001792526314__table163871610417"></a><a name="table163871610417"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001792526314__table163871610417" frame="border" border="1" rules="all"><caption><b>Table 2 </b>SQL Server cluster instance registration information</caption><colgroup><col style="width:25.629999999999995%"><col style="width:74.37%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="25.629999999999995%" id="mcps1.3.4.5.2.2.1.4.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="74.37%" id="mcps1.3.4.5.2.2.1.4.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000001792526314__en-us_topic_0000001792526314_b17667192119556">SQL Server Network Name</strong></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>Network name of the SQL Server. The default value is the host name.</p>
<p>The SQL Server network name of a Windows Server Failover Cluster (WSFC) is customized during cluster creation.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000001792526314__en-us_topic_0000001792526314_b43796208556">Named Instance</strong></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>Cluster instance name</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span><strong>Cluster</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>Database cluster to be registered.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span><strong>Nodes</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>Host where the database instance resides.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span><strong>Authentication Method</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>The cluster instance authentication mode can be OS authentication or database authentication.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span><strong>Database Username</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>Name of the database administrator.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.629999999999995%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.1 "><p><span><strong>Database Password</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.37%" headers="mcps1.3.4.5.2.2.1.4.2.2.3.1.2 "><p>Password of the database administrator.</p>
</td>
</tr>
</tbody>
</table>
</div>
</li><li>Click <span class="uicontrol"><b>OK</b></span>.</li></ol>
</p></li></ol>
</div>
<div class="section"><h4 class="sectiontitle">Related Operations</h4><ul><li>If the cluster is of the WSFC type, select all nodes.<p><span><img src="en-us_image_0000001920064725.png"></span></p>
</li><li>If the cluster is of the availability group type, register cluster instances one by one.<p><span><img src="en-us_image_0000001874065564.png"></span></p>
</li></ul>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="en-us_topic_0000001839245581.html">Backing Up a SQL Server Database</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>